package com.practice.springboot_01_zwj.mapper;

import com.practice.springboot_01_zwj.entity.*;
import org.apache.ibatis.annotations.*;

import java.util.List;
import java.util.Map;

@Mapper
public interface IncomeQuestionMapper {
    @Select("select * from gzt_income_mgr_question")
    List<IncomeQuestion> selectIncomeQuestionAll();
    Map<String,Object> selectIncomeByCityCode(@Param("cityCode") String cityCode,@Param("yearFilter") String yearFilter);
    Map<String,Object> selectIncomeByProvinceCode(@Param("provinceCode") String provinceCode,@Param("yearFilter") String yearFilter);
    Map<String,Object> selectMgrByCityCode(@Param("cityCode") String cityCode,@Param("yearFilter") String yearFilter);
    Map<String,Object> selectMgrByProvinceCode(@Param("provinceCode") String provinceCode,@Param("yearFilter") String yearFilter);

    Map<String,Object> selectQuestionByCityCode(@Param("cityCode") String cityCode,@Param("yearFilter") String yearFilter);
    Map<String,Object> selectQuestionByProvinceCode(@Param("provinceCode") String provinceCode,@Param("yearFilter") String yearFilter);
    List<IncomeQuestion> selectProvinceTotalIncome(@Param("provinceCode") String provinceCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectCityTotalIncome(@Param("cityCode") String cityCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectProvinceZtPro(@Param("provinceCode") String provinceCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectCityZtPro(@Param("cityCode") String cityCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectProvinceYjxPro(@Param("provinceCode") String provinceCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectCityYjxPro(@Param("cityCode") String cityCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectProvinceXsShangJi(@Param("provinceCode") String provinceCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectCityXsShangJi(@Param("cityCode") String cityCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectProvinceDyLxPro(@Param("provinceCode") String provinceCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectCityDyLxPro(@Param("cityCode") String cityCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectProvinceYlProNone(@Param("provinceCode") String provinceCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectCityYlProNone(@Param("cityCode") String cityCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectProvinceZbDlx(@Param("provinceCode") String provinceCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectCityZbDlx(@Param("cityCode") String cityCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectProvinceLxDqy(@Param("provinceCode") String provinceCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectCityLxDqy(@Param("cityCode") String cityCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectProvinceJfDys(@Param("provinceCode") String provinceCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectCityJfDys(@Param("cityCode") String cityCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectProvinceYqPro(@Param("provinceCode") String provinceCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectCityYqPro(@Param("cityCode") String cityCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectProvinceYqJdPro(@Param("provinceCode") String provinceCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectCityYqJdPro(@Param("cityCode") String cityCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectProvinceYqJfPro(@Param("provinceCode") String provinceCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectCityYqJfPro(@Param("cityCode") String cityCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectProvinceFjPro(@Param("provinceCode") String provinceCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectCityFjPro(@Param("cityCode") String cityCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectProvinceJtBz(@Param("provinceCode") String provinceCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectCityJtBz(@Param("cityCode") String cityCode,@Param("condition") IncomeQuestion incomeQuestion);

    List<IncomeQuestion> selectProvinceCzJf(@Param("provinceCode") String provinceCode,@Param("condition") IncomeQuestion incomeQuestion);
    List<IncomeQuestion> selectCityCzJf(@Param("cityCode") String cityCode,@Param("condition") IncomeQuestion incomeQuestion);

    //计划转收接口
    List<IncomeQuestion> selectCityCollection();
    //导出不分页
    List<IncomeQuestion> selectProvinceTotalIncomeAll(String provinceCode, IncomeQuestion condition);
    List<IncomeQuestion> selectCityTotalIncomeAll(String cityCode, IncomeQuestion condition);

}
